hacoDB
Tables (13)
haco_address
- PK (a_pk) — Primary key — NOT NULL
- PK (a_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
- 주소종류 (a_category)
- 주소값 (a_address)
haco_announcement
- PK (a_pk) — Primary key — NOT NULL
- 트위터ID (a_u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
- 제목 (a_title)
- 본문 (a_text)
- 작성일자 (a_date)
haco_archive
- PK (a_pk) — number (10) primary key — Primary key — NOT NULL
- 멤버PK (a_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
- 방송날짜 (a_date) — date not null
- 방송시각 (a_time) — INTERVAL DAY TO SECOND not null
- 콜라보여부 (a_collabo) — varchar2 (10 char) not null
- 콜라보멤버 (a_collabomember)
- 방송카테고리 (a_category) — varchar2 (50 char) not null
- 방송제목 (a_title) — varchar2 (200 char) not null
- 섬네일주소 (a_thumbnail) — varchar2 (100 char) not null
haco_comments
- PK (c_pk) — number(10) primary key — Primary key — NOT NULL
- 아카이브PK (c_a_pk) — number (10) — Foreign key → haco_archive.PK — NOT NULL
- 멤버PK (c_m_pk) — number3 — Foreign key → haco_archive.멤버PK — NOT NULL
- 트위터ID (u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
- 타임스탬프 (c_timestamp) — varchar2 (20 char) not null
- 댓글본문 (c_text) — varchar2 (100 char) not null
- 작성시간 (c_sysdate) — date not null
haco_goods
- PK (g_pk) — number (3) primary key — Primary key — NOT NULL
- 멤버PK (g_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
- 트위터ID (u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
- 굿즈종류 (g_category) — varchar2(50 char) not null
- 굿즈수량 (g_count) — number (2)
haco_hashtag
- PK (h_pk) — Primary key — NOT NULL
- PK (h_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
- 태그종류 (h_category)
- 태그값 (h_tag)
haco_image
- PK (i_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
- 아이콘 (i_icon) — varchar2(300 char)
- 정면도 (i_pic) — varchar2(300 char)
- 3면도 (i_3side) — varchar2(300 char)
- 배경 (i_background) — varchar2(300 char)
haco_member
- PK (m_pk) — number3 — Primary key — NOT NULL
- 이름 (m_name) — number3 not null
- 기수 (m_gen)
- 생일 (m_birth) — date not null
- 데뷔일 (m_debut) — date not null
- 마마이름 (m_mother_name) — varchar2(100 char) not null
- 마마트위터 (m_mother_twitter) — varchar2(100 char) not null
haco_schedule
- PK (s_pk) — Primary key — NOT NULL
- PK (s_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
- 트위터ID (s_u_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
- 날짜(요일) (s_date)
- 시간 (s_time)
- 제목 (s_title)
haco_songstream
- PK (s_pk) — number(10) primary key — Primary key — NOT NULL
- 아카이브PK (s_a_pk) — number (10) primary key — Foreign key → haco_archive.PK — NOT NULL
- 멤버PK (s_m_pk) — number3 — Foreign key → haco_archive.멤버PK — NOT NULL
- 트위터ID (u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
- 타임스탬프 (s_timestamp) — varchar2 (20 char) not null
- 노래이름 (s_songname) — varchar2 (100 char) not null
- 노래아티스트 (s_artistname) — varchar2 (100 char) not null
- 작성시간 (s_sysdate) — date not null
haco_tradegoods
- PK (t_pk) — number(10) — Primary key — NOT NULL
- 트위터ID (u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
- 본문 (t_text) — varchar2 (1000char)
- 작성일자 (t_sysdate) — date not null
haco_tradegoods_comments
- PK (tc_pk) — Primary key — NOT NULL
- 본문pk (tc_t_pk) — number(10) — Foreign key → haco_tradegoods.PK — NOT NULL
- 본문작성자-트위터ID (tc_m_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_tradegoods.트위터ID
- 댓글작성자-트위터ID (tc_s_twitter_id)
- 본문 (tc_text)
- 작성시간 (tc_date)
haco_user
- ID (u_id) — varchar2 (100 char) not null — Primary key
- PW (u_pw)
- 트위터ID (u_twitter_id)
- 닉네임 (u_nickname) — varchar2 (40 char) not null
- 활성화여부 (u_yesno)