test
Tables (7)
member
- id — NUMBER(30) — Primary key — NOT NULL
- name — VARCHAR2(20) — NOT NULL
- nickname — VARCHAR2(20) — NOT NULL
- birth — VARCHAR2(30) — NOT NULL
- email — VARCHAR2(50) — NOT NULL
- reg_date — DATE
member_tag
- id — NUMBER(30) — Foreign key → member.id — NOT NULL
- tag_id — NUMBER(30) — Foreign key → tag.tag_id — NOT NULL
photo
- photo_id — NUMBER(30) — Primary key — NOT NULL
- dir — VARCHAR2(100)
- filename — VARCHAR2(100)
- originname — VARCHAR2(50)
- filesize — NUMBER(30)
- filetype — VARCHAR2(50)
- reg_date — DATE
region
- region_id — NUMBER(30) — Primary key — NOT NULL
- si — VARCHAR2(10) — NOT NULL
- gu — VARCHAR2(10) — NOT NULL
tag
- tag_id — NUMBER(30) — Primary key — NOT NULL
- tag_name — VARCHAR2(10) — NOT NULL